##############################################################
## :    
## : Roman
##		  TorrentPier II: TorrentPier.me,Bustra
##   .
##     .
##     !!! 
##
## C : 
##
## ,   : ~ 1 
##
##  :
## includes/datastore/build_stats.php
## index.php
## templates/default/index.tpl
## language/lang_russian/lang_main.php
## language/lang_english/lang_main.php
##
##############################################################
##    ,       ,    
##############################################################


#
#-----[  ]------------------------------------------
#

includes/datastore/build_stats.php

#
#-----[  ]------------------------------------------
#
// Tracker stats
if ($bb_cfg['tor_stats'])
{
    // torrents stat
    $row = DB()->fetch_row("SELECT COUNT(topic_id) AS torrentcount, SUM(size) AS size FROM ". BB_BT_TORRENTS);
    $data['torrentcount'] = number_format($row['torrentcount']);
    $data['size'] = $row['size'];

    // peers stat
    $row = DB()->fetch_row("SELECT SUM(seeders) AS seeders, SUM(leechers) AS leechers, ((SUM(speed_up) + SUM(speed_down))/2) AS speed FROM ". BB_BT_TRACKER_SNAP);
    $data['seeders']  = number_format($row['seeders']);
    $data['leechers'] = number_format($row['leechers']);
    $data['peers']    = number_format($row['seeders'] + $row['leechers']);
    $data['speed']    = $row['speed'];
}
#
#-----[  :  ]------------------------------------------
# 
// Tracker stats
if ($bb_cfg['tor_stats'])
{
//up_down total
$sql = "SELECT ROUND(SUM(u_up_total+u_down_total)) AS pumped, ROUND(SUM(u_up_total)) AS upl, ROUND(SUM(u_down_total)) AS donl FROM " . BB_BT_USERS;
$row = DB()->fetch_row($sql);
$data['total_dl_ul'] = $row['pumped'];
$data['upload'] = $row['upl'];
$data['download'] = $row['donl'];
//up_down total end

//active seeders begin
$sql = 'SELECT COUNT(user_id) AS st   FROM '. BB_BT_TRACKER .' WHERE seeder = 1';
$row = DB()->fetch_row($sql);
$data['active_seeders'] = number_format($row['st']);
//active seeders end

//active leechers begin
$sql = 'SELECT COUNT(user_id) AS lt  FROM '. BB_BT_TRACKER .' WHERE seeder = 0';
$row = DB()->fetch_row($sql);
$data['active_leechers'] = number_format($row['lt']);
//active leechers end

//active leechers begin
$sql = 'SELECT COUNT(user_id) AS perv  FROM '. BB_BT_TRACKER .'';
$row = DB()->fetch_row($sql);
$data['active_peers_all'] = number_format($row['perv']);
//active leechers end

//active seeders begin
$sql = 'SELECT COUNT(DISTINCT user_id) AS stu   FROM '. BB_BT_TRACKER .' WHERE seeder = 1';
$row = DB()->fetch_row($sql);
$data['active_seeders_u'] = number_format($row['stu']);
//active seeders end

//active leechers begin
$sql = 'SELECT COUNT(DISTINCT user_id) AS ltu  FROM '. BB_BT_TRACKER .' WHERE seeder = 0';
$row = DB()->fetch_row($sql);
$data['active_leechers_u'] = number_format($row['ltu']);
//active leechers end

//active torrents begin
$sql = 'SELECT COUNT(DISTINCT tor.topic_id) AS tt , SUM(tor.size) AS ts
        FROM '. BB_BT_TRACKER .'  tr , '. BB_BT_TORRENTS .' tor
        WHERE tr.topic_id = tor.topic_id';
$row = DB()->fetch_row($sql);
$data['active_tor'] = number_format($row['tt']);
$data['active_tor_size'] = $row['ts'];
//active torrents end

//all torrents begin
$sql = ' SELECT COUNT(*) as tn, SUM(size) AS tos
         FROM '.BB_BT_TORRENTS;
$row = DB()->fetch_row($sql);
$data['all_tor'] = number_format($row['tn']);
$data['all_tor_size'] = $row['tos'];
//all torrents end

// users speed
$sql = 'SELECT sum(speed_up) AS s_ul, sum(speed_down) AS s_dl
         FROM bb_bt_tracker';
$row = DB()->fetch_row($sql);
$data['s_ul'] = $row['s_ul'];
$data['s_dl'] = $row['s_dl'];
// users speed
}
#
#-----[  ]------------------------------------------
#

index.php

#
#-----[    ]------------------------------------------
#
// Tracker stats
  'TORRENTS_STAT'     => sprintf($lang['Torrents_stat'], $stats['torrentcount'], humn_size($stats['size'])),
  'PEERS_STAT'        => sprintf($lang['Peers_stat'], $stats['peers'], $stats['seeders'], $stats['leechers']),
  'SPEED_STAT'        => sprintf($lang['Speed_stat'], humn_size($stats['speed']) .'/s'),
#
#-----[  ]------------------------------------------
#
define('SHOW_ONLINE', $show_online_users);
#
#-----[   ]------------------------------------------
# 
$template->assign_vars(array(
              'UD_ALL' => ($bb_cfg['tor_stats']) ? humn_size($stats['total_dl_ul']) : '',
              'UPL'    => ($bb_cfg['tor_stats']) ? humn_size($stats['upload']) : '',
              'S_UL'   => ($bb_cfg['tor_stats']) ? humn_size($stats['s_ul']) : '',
              'DNL'    => ($bb_cfg['tor_stats']) ? humn_size($stats['download']) : '',
              'S_DL'   => ($bb_cfg['tor_stats']) ? humn_size($stats['s_dl']) : '',
              'ST'     => ($bb_cfg['tor_stats']) ? $stats['active_seeders'] : '',
              'LT'     => ($bb_cfg['tor_stats']) ? $stats['active_leechers'] : '',
              'STU'    => ($bb_cfg['tor_stats']) ? $stats['active_seeders_u'] : '',
              'LTU'    => ($bb_cfg['tor_stats']) ? $stats['active_leechers_u'] : '',
              'PERV'   => ($bb_cfg['tor_stats']) ? $stats['active_peers_all'] : '',
              'TT'     => ($bb_cfg['tor_stats']) ? $stats['active_tor'] : '',
              'TS'     => ($bb_cfg['tor_stats']) ? humn_size($stats['active_tor_size']) : '',
              'TN'     => ($bb_cfg['tor_stats']) ? $stats['all_tor'] : '',
              'TOS'    => ($bb_cfg['tor_stats']) ? humn_size($stats['all_tor_size']) : '',
   ));
#
#-----[  ]------------------------------------------
#

templates/default/index.tpl

#
#-----[  ]------------------------------------------
#
<p>{TORRENTS_STAT}</p>
        <p>{PEERS_STAT}</p>
        <p>{SPEED_STAT}</p>
#
#-----[  :  ]------------------------------------------
# 
<b>{L_STATISTICS_TRACKER_S}</b><br/>
      <table border="0" cellspacing="0" cellpadding="0" height="65px">
          <tr>
              <td>
              <table border="1" cellspacing="0" cellpadding="0">
                  <tr>
                      <td>{L_SEEDING_S} </td>
                      <td><span class="seedmed"><b> {STU}</b></span></td>
                      <td><span class="seedmed">({S_UL}/s)</span></td>
                  </tr>
                  <tr>
                      <td>{L_DLDOWN_2} </td>
                      <td><span class="leechmed"><b> {LTU}</b></span></td>
                      <td><span class="leechmed">({S_DL}/s)</span></td>
                  </tr>
                  <tr>
                      <td>{L_TORRENT_S}</td>
                      <td><span class="genmed"><b>{TT}</b></span></td>
              <td><span class="genmed"><b>{TOS}</b></span></td>
                  </tr>
              </table>
              </td> 

              <td>
                  <table border="1" cellspacing="0" cellpadding="0" height="65px">
                  <tr>
                      <td>{L_TORRENT_D2} </td>
                      <td><span class="seedmed"><b> {UPL}</b></span></td>
                  </tr>
                  <tr>
                      <td>{L_TORRENT_S2} </td>
                      <td><span class="leechmed"><b> {DNL}</b></span></td>
                  </tr>
                  <tr>
                      <td>{L_TORRENT_FULL} </td>
                      <td><span class="genmed"><b>{TS}</b></span></td>
                  </tr>
                  </table>
              </td> 

              <td>
          <table border="1" cellspacing="0" cellpadding="0" height="65px">
          <tr>
                      <td>{L_PEERS_FULL} </td>
                      <td><span class="genmed"><b>{PERV}</b></span></td>
                      <td>
                <table border="0" cellspacing="0" cellpadding="0">
                  <tr>
                    <td class="seedmed">Seeders: </td>
                    <td class="seedmed"><b>{ST}</b></td>
                  </tr>
                  <tr>
                    <td class="leechmed">Leechers: </td>
                    <td class="leechmed"><b>{LT}</b></td>
                  </tr>
                </table>
                      </td>
                  </tr>
                  </table>
              </td>
          </tr>
      </table>
#
#-----[  ]------------------------------------------
#

language/lang_russian/lang_main.php

#
#-----[  ]------------------------------------------
#
?>
#
#-----[   ]------------------------------------------
# 
//
//    
//
$lang['STATISTICS_TRACKER_S'] = '  :';
$lang['SEEDING_S'] = ':';
$lang['DLDOWN_2'] = ':';
$lang['TORRENT_S'] = ':';
$lang['TORRENT_D2'] = '  :';
$lang['TORRENT_S2'] = '  :';
$lang['TORRENT_FULL'] = '  :';
$lang['PEERS_FULL'] = ' :';
#
#-----[  ]------------------------------------------
#

language/lang_english/lang_main.php

#
#-----[  ]------------------------------------------
#
?>
#
#-----[   ]------------------------------------------
# 
//
//    
//
$lang['STATISTICS_TRACKER_S'] = 'Statistics on the tracker:';
$lang['SEEDING_S'] = 'Seeding:';
$lang['DLDOWN_2'] = 'Leeching:';
$lang['TORRENT_S'] = 'Torrents:';
$lang['TORRENT_D2'] = 'Seeding through tracker:';
$lang['TORRENT_S2'] = 'Leeching through tracker:';
$lang['TORRENT_FULL'] = 'Total size of torrents:';
$lang['PEERS_FULL'] = 'Peers:';
#
#-----[ /   ]------------------------------------------
#
# !